/*************************************************************************
    > File Name: select1.c
    > Author: liyisheng
    > Mail: liyishengchn@gmail.com 
    > Created Time: Mon 04 May 2015 04:54:44 PM CST
 ************************************************************************/

#include<stdio.h>
#include<stdlib.h>

#include<mysql/mysql.h>


int main()
{
	MYSQL my_connection;	
	MYSQL_RES *res_ptr;
	MYSQL_ROW sqlrow;
	int res;

	mysql_init(&my_connection);
	if(mysql_real_connect(&my_connection, "server", "rick", "rick", "foo", 0, NULL, 0))
	{
		printf("Connection success\n");
		//res = mysql_query(&my_connection, "SELECT childno, fname, age FROM children WHERE age > 5");
		res = mysql_query(&my_connection, "SELECT * from children");

		if(res)
			printf("SELECT error : %s\n", mysql_error(&my_connection));
		else
		{
			res_ptr = mysql_store_result(&my_connection);
			if(res_ptr)
			{
	//			printf("Retrieved %lu rows", (unsigned long)mysql_num_rows(res_ptr));
				while((sqlrow = mysql_fetch_row(res_ptr)))
					printf("Fetched data...\n");

				if(mysql_errno(&my_connection))
					fprintf(stderr, "Retrive error : %s\n", mysql_errno(&my_connection), mysql_error(&my_connection));
			}
			mysql_free_result(res_ptr);
		}
		mysql_close(&my_connection);
	}else
	{
		fprintf(stderr, "Connection failed\n");
		if(mysql_errno(&my_connection))
			fprintf(stderr, "Connection error %d: %s\n", mysql_errno(&my_connection), mysql_error(&my_connection));
	}

	return EXIT_SUCCESS;
}
